<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateAssociatorTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('associators', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name')->nullable()->comment('真实姓名');
            $table->string('sex')->nullable()->comment('性别');
            $table->string('username')->nullable()->comment('昵称');
            $table->double('score')->nullable()->comment('评分'); // 星级
            $table->integer('age')->nullable()->comment('年龄');
            $table->string('area')->nullable()->comment('地区');
            $table->string('status')->nullable()->comment('状态'); // 正常、待审核
            $table->string('if_anchor')->nullable()->comment('是否是导师');
            $table->integer('order_num')->nullable()->comment('接单次数');
            $table->integer('vip')->nullable()->comment('vip等级'); // 普通会员有vip等级
            $table->integer('glamour')->nullable()->comment('魅力值');
            $table->string('height')->nullable()->comment('身高');
            $table->string('weigh')->nullable()->comment('体重');
            $table->string('constellation')->nullable()->comment('星座');
            $table->string('occupation')->nullable()->comment('职业'); // 从职业表中拿到的
            $table->string('current_status')->nullable()->comment('当前状态'); // 忙碌 下线 空闲
            $table->string('authentication')->nullable()->comment('是否真人认证'); // 在陪玩页需要
            $table->text('portrait')->nullable()->comment('头像');
            $table->string('qq')->nullable()->comment('qq号');
            $table->string('password')->comment('密码');
            $table->string('mobile')->nullable()->comment('手机号');
            $table->string('wechat')->nullable()->comment('微信号');
            $table->string('credit')->nullable()->comment('银行卡号');
            $table->string('id_num')->nullable()->comment('身份证号');
            $table->string('birthday')->nullable()->comment('出生日期');
            $table->string('province')->nullable()->comment('省');
            $table->string('city')->nullable()->comment('市');
            $table->text('signature')->nullable()->comment('个性签名');
            $table->string('hobby')->nullable()->comment('兴趣爱好');
            $table->string('video')->nullable()->comment('自拍视频，审核后真人认证');
            $table->string('voice')->nullable()->comment('语音介绍');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('associators');
    }
}
